UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zMsqV7Ft6kj4yxF8kJyKfzAPqDay7fs1BBk9RiNvdTo='
WHERE
key_id = 'e645f9345c61dda2c81210824a78cc3ca443ac2b19faf91caa26b5962b155fe4'
AND (
token = 'zMsqV7Ft6kj4yxF8kJyKfzAPqDay7fs1BBk9RiNvdTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)