UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lN8tV7uqVSvCbiNleu3rKUuWQz7L5mu8YUJz7/ErlBU='
WHERE
key_id = '89c91965845b805667bea25a7f525530dd1fe587296a580409353a74f5c8c3af'
AND (
token = 'lN8tV7uqVSvCbiNleu3rKUuWQz7L5mu8YUJz7/ErlBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)