UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCaMjcV0DEKohPgUlYZWPQ1B1XvellLxhO+LsHhG2sc='
WHERE
key_id = 'c8038a9768d610fbf04bad44a66e2fcbdb73528341f39f51b29308db41c9890a'
AND (
token = 'JCaMjcV0DEKohPgUlYZWPQ1B1XvellLxhO+LsHhG2sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)