UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THnxIz73g0G3jlDwDHf4Iq14aAbdaxbQ/Kfb3j7N+E8='
WHERE
key_id = 'f6f1e7b0929094a0662584075de0a0065e5777eb10ccd3e5f93d8de3a855b1bc'
AND (
token = 'THnxIz73g0G3jlDwDHf4Iq14aAbdaxbQ/Kfb3j7N+E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)