UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opHtA1kQK8ULP4WgULrKL7Q2BFJhDYLquKPjiRz1kfU='
WHERE
key_id = '1c57f6abd47fb25c7756135a485eeb6d09d92e918cd4cdd7f7509ef125691867'
AND (
token = 'opHtA1kQK8ULP4WgULrKL7Q2BFJhDYLquKPjiRz1kfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)