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