UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mrTkKJPYXK7uHjCBKw7jYDFxtfimokRXIni40O8d8VU='
WHERE
key_id = '7c2a1421a1f1043b88685922531c67594faaabc25afb6ded2bc566b4a09a46a8'
AND (
token = 'mrTkKJPYXK7uHjCBKw7jYDFxtfimokRXIni40O8d8VU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)