UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UK+fP2XRoQf2jx1FPxi1tis/1i6sPufltgxcl4kiLUc='
WHERE
key_id = 'ca162e91f9adc1ab642ea40dcd5eaaffac363d693215e8e037b9cf1b9991e156'
AND (
token = 'UK+fP2XRoQf2jx1FPxi1tis/1i6sPufltgxcl4kiLUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)