UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bQU0uFXLg2EAX+4YRCHm8W4DNeEZCigtUdq4MJf60OM='
WHERE
key_id = '1e6d57aca063b6c0fc9353a94ca31fe184227e4248a6cb8116dfa202b768a337'
AND (
token = 'bQU0uFXLg2EAX+4YRCHm8W4DNeEZCigtUdq4MJf60OM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)