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