UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2c3gsadu8wO0+rHcZlY2B/UvWZBdPdHVAW7foMaHQM='
WHERE
key_id = 'e0eeaa6c1bebba3d6fd58866744f0dc6743e2e2ae607047a89996be516d47174'
AND (
token = 'z2c3gsadu8wO0+rHcZlY2B/UvWZBdPdHVAW7foMaHQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)