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