UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lnJ43SZOydkdgzQYCkNfSKMIttug2TSGbgEVWZuwXuo='
WHERE
key_id = '7152803965f54e3a32fda11c8a11903b8514429697f872f9e8fa2708505fac16'
AND (
token = 'lnJ43SZOydkdgzQYCkNfSKMIttug2TSGbgEVWZuwXuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)