UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cn9K/vvoMYnXtHVy9POnOW/UJNqyrtAupHfp0VaiN+E='
WHERE
key_id = 'eef78f9f923938c1a8d9ceed8897bf1abebcc31733e2f6954fc219ee09c87125'
AND (
token = 'Cn9K/vvoMYnXtHVy9POnOW/UJNqyrtAupHfp0VaiN+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)