UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tz+OCH1t2Cq3ERO4pZ4pCZpL5D9mcmktFaowNLpn93o='
WHERE
key_id = 'a75c9c487b1884a50ced8f43a1f868a239760318bb5613bc5a80453d63cc2188'
AND (
token = 'Tz+OCH1t2Cq3ERO4pZ4pCZpL5D9mcmktFaowNLpn93o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)