UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v6KXP9rtacedWf9w8gvkIKBcgQpdiIEhTEPy1RVBu2I='
WHERE
key_id = '6b24dd22174356b452daac466eaa15f718ac9901b6f90716120384f2c86aa4e1'
AND (
token = 'v6KXP9rtacedWf9w8gvkIKBcgQpdiIEhTEPy1RVBu2I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)