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