UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PgTkzwJRYjRgWpC0uNVPsyFsC15/lws/Y6lYQ57PuXI='
WHERE
key_id = '1df647b0c34384308524fac03e92972a46d20d51368560fd647707cf94d76864'
AND (
token = 'PgTkzwJRYjRgWpC0uNVPsyFsC15/lws/Y6lYQ57PuXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)