UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcB1gMtbqbtGaTe2m3UiXYt6lDHeA7bXiJ1Wo2AuG60='
WHERE
key_id = '9f3139e5b9b8e7cdb71ded51dd8a427db0c3c48bb73373b1b7c63ea9fdf3a8e3'
AND (
token = 'BcB1gMtbqbtGaTe2m3UiXYt6lDHeA7bXiJ1Wo2AuG60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)