UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rzd91IcV3mciew431euxjWNf1zdWmFR3eFlBfEliyr0='
WHERE
key_id = '2627735e4efa78c3526b599901111b5818e01c4c0a44b968808d6b656a9e4973'
AND (
token = 'rzd91IcV3mciew431euxjWNf1zdWmFR3eFlBfEliyr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)