UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nxwz6skUSCsRY5s9yXR36pQIXPPswTU74aXABrBXmRA='
WHERE
key_id = '1005583c8b2bc7262f79597e46f3cd273c0359987d59d0eef34158c19e70a022'
AND (
token = 'Nxwz6skUSCsRY5s9yXR36pQIXPPswTU74aXABrBXmRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)