UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhvzfJ0yIrB0EkqHuQjIEtNpuzL5zjlw0bsnApYxSRA='
WHERE
key_id = '080aa78971e8b046136bf0bf629367797b87bc2ac0a65647af09e5877dd5f6c6'
AND (
token = 'fhvzfJ0yIrB0EkqHuQjIEtNpuzL5zjlw0bsnApYxSRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)