UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GnWSbhSVU+x2mdg7BKKpU8uYFJeEwHZrNLF8aQoFkRw='
WHERE
key_id = 'ad7410278cb88122959797001a940864576d7de20165ecf3eac6a92c98256031'
AND (
token = 'GnWSbhSVU+x2mdg7BKKpU8uYFJeEwHZrNLF8aQoFkRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)