UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '166lrSuGe6qjTuyOPPPO5kiiJ06+CfVYKb4PzFS1aic='
WHERE
key_id = '24130ffb29d140fa889a4e051ec23178c0fe2abeef45cd8d97b56c571649d62c'
AND (
token = '166lrSuGe6qjTuyOPPPO5kiiJ06+CfVYKb4PzFS1aic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)