UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZC9R/j3a7O1BgzzMee+x084LOdJIeQOhii8LXC6o23c='
WHERE
key_id = '7afa6d71ea3d71275618ed59c43077e473b4b208b55b84936ed84de934f0f373'
AND (
token = 'ZC9R/j3a7O1BgzzMee+x084LOdJIeQOhii8LXC6o23c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)