UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H7PxNZwepGu2g8Lp0vY0+LQSXg+iEJgtdiojSyUe93A='
WHERE
key_id = 'c39824d0f716e1b2bf8e6e0f4ccc1e5a41551f36341613aac22d71614a67a402'
AND (
token = 'H7PxNZwepGu2g8Lp0vY0+LQSXg+iEJgtdiojSyUe93A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)