UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkiDG0k32/l+4hb7rFC3vV1H0yFssB5W1HhLGbcV9ko='
WHERE
key_id = 'ecfb4a977684cf0ef3dcafd2b782ff4e5a17c883874a59908752b232201ec7e5'
AND (
token = 'gkiDG0k32/l+4hb7rFC3vV1H0yFssB5W1HhLGbcV9ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)