UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/plRRk2XvhRZNBhLZG57r2t79ZWF5PdUK9Rc1x+x9ww='
WHERE
key_id = 'b1855020303b30a285e078b1af7a6b1ed156face63e2f62a6e37594b703fa0ca'
AND (
token = '/plRRk2XvhRZNBhLZG57r2t79ZWF5PdUK9Rc1x+x9ww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)