UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1DSWJChPly4u0Q4yTvbOC6BvVgNhNv+pij02rcCtiSE='
WHERE
key_id = '8e4e1674a8904f9a8c58a525ebd59351c7d8fc30c811416b8079a16dfb8f8572'
AND (
token = '1DSWJChPly4u0Q4yTvbOC6BvVgNhNv+pij02rcCtiSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)