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