UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UeRGdx832Y8tzb7RNvEVkyswbTQxlS3YkJxX7cd3Gk='
WHERE
key_id = '0e3b167a82a028cb31d236ae47c7e0101ad27c52b619e82f199e274d7b4b7787'
AND (
token = '7UeRGdx832Y8tzb7RNvEVkyswbTQxlS3YkJxX7cd3Gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)