UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4qP32yKDaoYjnny/1fcY/IGTGGkAHrNor8JCWB8pjgM='
WHERE
key_id = '1d53d07febff21364591f3016260b1fc9f927e048f29ac56b209c5df8b99347e'
AND (
token = '4qP32yKDaoYjnny/1fcY/IGTGGkAHrNor8JCWB8pjgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)