UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UzlX9JTievRC3F585oKs4DjEBzQ1Plaeo3wKjuN0pLA='
WHERE
key_id = 'b9871eaf7ea09a6800692708dafebc96ca671084d1fe8f8edf29b1cf6ec5fe36'
AND (
token = 'UzlX9JTievRC3F585oKs4DjEBzQ1Plaeo3wKjuN0pLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)